<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, database.*" %>
<jsp:useBean id="con" class="database.DatabaseConnection"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Audit Plan</title>
<style type="text/css">
<!--
body {
	background-image: url(image/3110_background/backcolor3.jpg);
	background-repeat: repeat;
}
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
  <table width="917" border="1">
    <tr>
      <td colspan="4" align="center" valign="middle">Audit Plan</td>
    </tr>
    <tr>
      <td align="center" valign="middle">Intake</td>
      <td align="center" valign="middle">Rim</td>
      <td align="center" valign="middle">Charger</td>
      <td align="center" valign="middle">Car Model</td>
    </tr>
 <%
        con.createConnection();
        ResultSet rs = con.getUser_Car_Information_Parameter();
        String Intake = null;
        String Rim = null;
        String Charger = null;
        String carModel = null;

                    for (int j = 0; j < 15; j++) {
                        if (rs.next()) {
                            Intake = rs.getString("User_Car_Information_Parameter_Intake_ID");
                            Rim = rs.getString("User_Car_Information_Parameter_Rim_ID");
                            Charger = rs.getString("User_Car_Information_Parameter_Charger_ID");
                            carModel = rs.getString("User_Car_Information_Parameter_Car_Model");
                    %>
                    <tr align="left" valign="top">
                    <td align="center" valign="middle"><%=Intake%></td>
                    <td align="center" valign="middle"><%=Rim%></td>
                    <td align="center" valign="middle"><%=Charger%></td>
                    <td align="center" valign="middle"><%=carModel%></td>
                    </tr>
                    <%
                        }
                    }
                    %>
                    </table>
</form>
</body>
</html>
